pip install -U pandas-profiling
Defaulting to user installation because normal site-packages is not writeable Collecting pandas-profiling Downloading pandas_profiling-3.6.6-py2.py3-none-any.whl (324 kB) Collecting ydata-profiling Downloading ydata_profiling-4.3.1-py2.py3-none-any.whl (352 kB) Requirement already satisfied: scipy<1.11,>=1.4.1 in c:\programdata\anaconda3\lib\site-packages (from ydata-profiling->pandas-profiling) (1.7.3) Collecting wordcloud>=1.9.1 Downloading wordcloud-1.9.2-cp39-cp39-win_amd64.whl (153 kB) Requirement already satisfied: seaborn<0.13,>=0.10.1 in c:\programdata\anaconda3\lib\site-packages (from ydata-profiling->pandas-profiling) (0.11.2) Collecting pydantic<2,>=1.8.1 Downloading pydantic-1.10.11-cp39-cp39-win_amd64.whl (2.2 MB) Requirement already satisfied: PyYAML<6.1,>=5.0.0 in c:\programdata\anaconda3\lib\site-packages (from ydata-profiling->pandas-profiling) (6.0) Collecting dacite>=1.8 Downloading dacite-1.8.1-py3-none-any.whl (14 kB) Requirement already satisfied: numpy<1.24,>=1.16.0 in c:\programdata\anaconda3\lib\site-packages (from ydata-profiling->pandas-profiling) (1.21.5) Requirement already satisfied: statsmodels<1,>=0.13.2 in c:\programdata\anaconda3\lib\site-packages (from ydata-profiling->pandas-profiling) (0.13.2) Requirement already satisfied: matplotlib<4,>=3.2 in c:\programdata\anaconda3\lib\site-packages (from ydata-profiling->pandas-profiling) (3.5.1) Requirement already satisfied: tqdm<5,>=4.48.2 in c:\programdata\anaconda3\lib\site-packages (from ydata-profiling->pandas-profiling) (4.64.0) Requirement already satisfied: pandas!=1.4.0,<2.1,>1.1 in c:\programdata\anaconda3\lib\site-packages (from ydata-profiling->pandas-profiling) (1.4.2) Collecting typeguard<3,>=2.13.2 Downloading typeguard-2.13.3-py3-none-any.whl (17 kB) Collecting imagehash==4.3.1 Downloading ImageHash-4.3.1-py2.py3-none-any.whl (296 kB) Collecting htmlmin==0.1.12 Downloading htmlmin-0.1.12.tar.gz (19 kB) Collecting multimethod<2,>=1.4 Downloading multimethod-1.9.1-py3-none-any.whl (10 kB) Requirement already satisfied: requests<3,>=2.24.0 in c:\programdata\anaconda3\lib\site-packages (from ydata-profiling->pandas-profiling) (2.27.1) Collecting visions[type_image_path]==0.7.5 Downloading visions-0.7.5-py3-none-any.whl (102 kB) Requirement already satisfied: jinja2<3.2,>=2.11.1 in c:\programdata\anaconda3\lib\site-packages (from ydata-profiling->pandas-profiling) (2.11.3) Collecting phik<0.13,>=0.11.1 Downloading phik-0.12.3-cp39-cp39-win_amd64.whl (663 kB) Requirement already satisfied: PyWavelets in c:\programdata\anaconda3\lib\site-packages (from imagehash==4.3.1->ydata-profiling->pandas-profiling) (1.3.0) Requirement already satisfied: pillow in c:\programdata\anaconda3\lib\site-packages (from imagehash==4.3.1->ydata-profiling->pandas-profiling) (9.0.1) Requirement already satisfied: networkx>=2.4 in c:\programdata\anaconda3\lib\site-packages (from visions[type_image_path]==0.7.5->ydata-profiling->pandas-profiling) (2.7.1) Collecting tangled-up-in-unicode>=0.0.4 Downloading tangled_up_in_unicode-0.2.0-py3-none-any.whl (4.7 MB) Requirement already satisfied: attrs>=19.3.0 in c:\programdata\anaconda3\lib\site-packages (from visions[type_image_path]==0.7.5->ydata-profiling->pandas-profiling) (21.4.0) Requirement already satisfied: MarkupSafe>=0.23 in c:\programdata\anaconda3\lib\site-packages (from jinja2<3.2,>=2.11.1->ydata-profiling->pandas-profiling) (2.0.1) Requirement already satisfied: packaging>=20.0 in c:\programdata\anaconda3\lib\site-packages (from matplotlib<4,>=3.2->ydata-profiling->pandas-profiling) (21.3) Requirement already satisfied: cycler>=0.10 in c:\programdata\anaconda3\lib\site-packages (from matplotlib<4,>=3.2->ydata-profiling->pandas-profiling) (0.11.0) Requirement already satisfied: kiwisolver>=1.0.1 in c:\programdata\anaconda3\lib\site-packages (from matplotlib<4,>=3.2->ydata-profiling->pandas-profiling) (1.3.2) Requirement already satisfied: pyparsing>=2.2.1 in c:\programdata\anaconda3\lib\site-packages (from matplotlib<4,>=3.2->ydata-profiling->pandas-profiling) (3.0.4) Requirement already satisfied: fonttools>=4.22.0 in c:\programdata\anaconda3\lib\site-packages (from matplotlib<4,>=3.2->ydata-profiling->pandas-profiling) (4.25.0) Requirement already satisfied: python-dateutil>=2.7 in c:\programdata\anaconda3\lib\site-packages (from matplotlib<4,>=3.2->ydata-profiling->pandas-profiling) (2.8.2) Requirement already satisfied: pytz>=2020.1 in c:\programdata\anaconda3\lib\site-packages (from pandas!=1.4.0,<2.1,>1.1->ydata-profiling->pandas-profiling) (2021.3) Requirement already satisfied: joblib>=0.14.1 in c:\programdata\anaconda3\lib\site-packages (from phik<0.13,>=0.11.1->ydata-profiling->pandas-profiling) (1.1.0) Collecting typing-extensions>=4.2.0 Downloading typing_extensions-4.7.1-py3-none-any.whl (33 kB) Requirement already satisfied: six>=1.5 in c:\programdata\anaconda3\lib\site-packages (from python-dateutil>=2.7->matplotlib<4,>=3.2->ydata-profiling->pandas-profiling) (1.16.0) Requirement already satisfied: certifi>=2017.4.17 in c:\programdata\anaconda3\lib\site-packages (from requests<3,>=2.24.0->ydata-profiling->pandas-profiling) (2021.10.8) Requirement already satisfied: idna<4,>=2.5 in c:\programdata\anaconda3\lib\site-packages (from requests<3,>=2.24.0->ydata-profiling->pandas-profiling) (3.3) Requirement already satisfied: charset-normalizer~=2.0.0 in c:\programdata\anaconda3\lib\site-packages (from requests<3,>=2.24.0->ydata-profiling->pandas-profiling) (2.0.4) Requirement already satisfied: urllib3<1.27,>=1.21.1 in c:\programdata\anaconda3\lib\site-packages (from requests<3,>=2.24.0->ydata-profiling->pandas-profiling) (1.26.9) Requirement already satisfied: patsy>=0.5.2 in c:\programdata\anaconda3\lib\site-packages (from statsmodels<1,>=0.13.2->ydata-profiling->pandas-profiling) (0.5.2) Requirement already satisfied: colorama in c:\programdata\anaconda3\lib\site-packages (from tqdm<5,>=4.48.2->ydata-profiling->pandas-profiling) (0.4.4) Building wheels for collected packages: htmlmin Building wheel for htmlmin (setup.py): started Building wheel for htmlmin (setup.py): still running... Building wheel for htmlmin (setup.py): finished with status 'done' Created wheel for htmlmin: filename=htmlmin-0.1.12-py3-none-any.whl size=27096 sha256=dea19bf5d68ddb9d2f27897f127a6e488a7958bcc3b9c9de44d31a995b9510af Stored in directory: c:\users\gilda.tahani\appdata\local\pip\cache\wheels\1d\05\04\c6d7d3b66539d9e659ac6dfe81e2d0fd4c1a8316cc5a403300 Successfully built htmlmin Installing collected packages: tangled-up-in-unicode, multimethod, visions, typing-extensions, imagehash, wordcloud, typeguard, pydantic, phik, htmlmin, dacite, ydata-profiling, pandas-profiling Successfully installed dacite-1.8.1 htmlmin-0.1.12 imagehash-4.3.1 multimethod-1.9.1 pandas-profiling-3.6.6 phik-0.12.3 pydantic-1.10.11 tangled-up-in-unicode-0.2.0 typeguard-2.13.3 typing-extensions-4.7.1 visions-0.7.5 wordcloud-1.9.2 ydata-profiling-4.3.1 Note: you may need to restart the kernel to use updated packages.
WARNING: The script wordcloud_cli.exe is installed in 'C:\Users\gilda.tahani\AppData\Roaming\Python\Python39\Scripts' which is not on PATH. Consider adding this directory to PATH or, if you prefer to suppress this warning, use --no-warn-script-location. WARNING: The script phik_trial.exe is installed in 'C:\Users\gilda.tahani\AppData\Roaming\Python\Python39\Scripts' which is not on PATH. Consider adding this directory to PATH or, if you prefer to suppress this warning, use --no-warn-script-location. WARNING: The script htmlmin.exe is installed in 'C:\Users\gilda.tahani\AppData\Roaming\Python\Python39\Scripts' which is not on PATH. Consider adding this directory to PATH or, if you prefer to suppress this warning, use --no-warn-script-location. WARNING: The scripts pandas_profiling.exe and ydata_profiling.exe are installed in 'C:\Users\gilda.tahani\AppData\Roaming\Python\Python39\Scripts' which is not on PATH. Consider adding this directory to PATH or, if you prefer to suppress this warning, use --no-warn-script-location. WARNING: The script pandas_profiling.exe is installed in 'C:\Users\gilda.tahani\AppData\Roaming\Python\Python39\Scripts' which is not on PATH. Consider adding this directory to PATH or, if you prefer to suppress this warning, use --no-warn-script-location.
conda install -c conda-forge pandas-profiling
Collecting package metadata (current_repodata.json): ...working... done
Solving environment: ...working... done
## Package Plan ##
environment location: C:\ProgramData\Anaconda3
added / updated specs:
- pandas-profiling
The following packages will be downloaded:
package | build
---------------------------|-----------------
conda-4.14.0 | py39hcbf5309_0 1.0 MB conda-forge
pandas-profiling-1.4.1 | 0 40 KB conda-forge
python_abi-3.9 | 2_cp39 4 KB conda-forge
------------------------------------------------------------
Total: 1.1 MB
The following NEW packages will be INSTALLED:
pandas-profiling conda-forge/win-64::pandas-profiling-1.4.1-0
python_abi conda-forge/win-64::python_abi-3.9-2_cp39
The following packages will be UPDATED:
conda pkgs/main::conda-4.12.0-py39haa95532_0 --> conda-forge::conda-4.14.0-py39hcbf5309_0
Downloading and Extracting Packages
python_abi-3.9 | 4 KB | | 0%
python_abi-3.9 | 4 KB | ########## | 100%
python_abi-3.9 | 4 KB | ########## | 100%
conda-4.14.0 | 1.0 MB | | 0%
conda-4.14.0 | 1.0 MB | ########## | 100%
conda-4.14.0 | 1.0 MB | ########## | 100%
pandas-profiling-1.4 | 40 KB | | 0%
pandas-profiling-1.4 | 40 KB | ########## | 100%
pandas-profiling-1.4 | 40 KB | ########## | 100%
Preparing transaction: ...working... done
Verifying transaction: ...working... failed
Note: you may need to restart the kernel to use updated packages.
==> WARNING: A newer version of conda exists. <==
current version: 4.12.0
latest version: 23.5.2
Please update conda by running
$ conda update -n base -c defaults conda
EnvironmentNotWritableError: The current user does not have write permissions to the target environment.
environment location: C:\ProgramData\Anaconda3
import numpy as np
import pandas as pd
from pandas_profiling import ProfileReport
C:\Users\gilda.tahani\AppData\Local\Temp\ipykernel_8084\2274191625.py:1: DeprecationWarning: `import pandas_profiling` is going to be deprecated by April 1st. Please use `import ydata_profiling` instead. from pandas_profiling import ProfileReport
data = pd.read_csv("Anime.csv")
data
| username | anime_id | my_score | user_id | gender | title | type | source | score | scored_by | rank | popularity | genre | Duration | Rating | Members | Favorites | Completed | On-Hold | Dropped | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | karthiga | 21 | 9 | 2255153 | Female | One Piece | TV | Manga | 8.54 | 423868.0 | 91 | 35 | Action, Adventure, Comedy, Super Power, Drama,... | 24 min. per ep. | R - 17+ (violence & profanity) | 1251960 | 61971 | 718161 | 71513 | 26678 |
| 1 | RedvelvetDaisuki | 918 | 0 | 1897606 | Female | Gintama | TV | Manga | 9.01 | 141830.0 | 15 | 95 | Action, Sci-Fi, Comedy, Historical, Parody, Sa... | 1 hr. 55 min. | R - 17+ (violence & profanity) | 273145 | 1174 | 208333 | 1935 | 770 |
| 2 | RedvelvetDaisuki | 9479 | 3 | 1897606 | Female | Coppelion | TV | Manga | 6.54 | 37299.0 | 5443 | 949 | Action, Sci-Fi, Seinen | 24 min. per ep. | PG-13 - Teens 13 or older | 558913 | 12944 | 718161 | 71513 | 13925 |
| 3 | RedvelvetDaisuki | 22135 | 8 | 1897606 | Female | Ping Pong The Animation | TV | Manga | 8.65 | 72887.0 | 58 | 563 | Sports, Psychological, Drama, Seinen | 25 min. per ep. | PG-13 - Teens 13 or older | 94683 | 587 | 718161 | 71513 | 5378 |
| 4 | Damonashu | 1829 | 6 | 37326 | Male | Gedo Senki | Movie | Novel | 7.13 | 44087.0 | 3072 | 1125 | Adventure, Fantasy, Magic | 23 min. per ep. | PG - Children | 13224 | 18 | 718161 | 766 | 1108 |
| ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... |
| 4920 | Sam_J | 32696 | 6 | 26952 | Male | Fukigen na Mononokean | TV | Web manga | 7.45 | 26464.0 | 1804 | 1253 | Comedy, Demons, Supernatural | 15 min. per ep. | PG-13 - Teens 13 or older | 148259 | 8 | 150183 | 112 | 100 |
| 4921 | nikekid9387 | 343 | 7 | 68295 | Male | Tsukuyomi: Moon Phase | TV | Manga | 7.10 | 21039.0 | 3218 | 1475 | Comedy, Romance, Vampire, Fantasy, Seinen | 15 min. | PG-13 - Teens 13 or older | 148259 | 12 | 150183 | 1935 | 104 |
| 4922 | Retridemption | 885 | 0 | 531285 | Female | Tenshi no Tamago | OVA | Original | 7.63 | 20757.0 | 1282 | 1478 | Fantasy, Dementia, Drama | 24 min. per ep. | PG-13 - Teens 13 or older | 490554 | 8762 | 718161 | 12737 | 16529 |
| 4923 | Retridemption | 2369 | 7 | 531285 | Female | Rental Magica | TV | Light novel | 7.14 | 15714.0 | 3053 | 1620 | Mystery, Supernatural, Fantasy | 15 min. per ep. | PG - Children | 382 | 0 | 718161 | 296 | 51 |
| 4924 | Retridemption | 4282 | 10 | 531285 | Female | Kara no Kyoukai 5: Mujun Rasen | Movie | Light novel | 8.63 | 78701.0 | 65 | 594 | Action, Mystery, Supernatural, Drama, Romance,... | 16 min. | PG - Children | 335 | 0 | 208333 | 1935 | 118 |
4925 rows × 20 columns
profile = ProfileReport(data, title="Pandas Profiling Report")
data.profile_report()
Summarize dataset: 0%| | 0/5 [00:00<?, ?it/s]
Generate report structure: 0%| | 0/1 [00:00<?, ?it/s]
Render HTML: 0%| | 0/1 [00:00<?, ?it/s]
profile.to_file("EDA_report.html")
Summarize dataset: 0%| | 0/5 [00:00<?, ?it/s]
Generate report structure: 0%| | 0/1 [00:00<?, ?it/s]
Render HTML: 0%| | 0/1 [00:00<?, ?it/s]
Export report to file: 0%| | 0/1 [00:00<?, ?it/s]